OpenCities Map CONNECT Edition Help

Importing an ODBC Data Source

The process for importing an ODBC source is similar to that for CSV with slight changes to the format of the VRT file. The ODBC VRT file is shown below.

<OGRVRTDataSource>
   <OGRVRTLayer name="town_aus">
       <SrcDataSource>ODBC:town_aus</SrcDataSource>
        <SrcLayer>City</SrcLayer> 
       <GeometryType>wkbPoint</GeometryType>
       <LayerSRS>WGS84</LayerSRS>
       <GeometryField encoding="PointFromColumns" x="longitude" y="latitude"/>
   </OGRVRTLayer> 
</OGRVRTDataSource>

First, set up an ODBC data source to the Microsoft Access data file. In this example the ODBC data source is called town_aus and is described in the SrcDataSource tag above. A new entry describing the layer name is also added. This points to the table named City in Microsoft Access. All other tags remain the same.